package com.test.mapper;

import com.test.pojo.User;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @author 宋建华
 * @return
 * @date 2023-12-29
 */
@Mapper
public interface WebMapper {

    @Select("select * from `user` where username =#{username}")
    User SelectByUserName(String username);

    @Insert("insert into `user`(username,password,name ,phone ,email ,address ,avatar) " +
            "values(#{username},#{password},#{name},#{phone},#{email},#{address},#{avatar})")
    void insert(User user);
}
